跳到主要内容

FreezePaneType

Specifies a type of freeze panes.

Type​

Enumeration

Values​

  • "row"
  • "column"
  • "cell"
  • null

Example​

This example freezes first column and get pastes a freezed range address into the table.

builder.CreateFile("xlsx");
Api.SetFreezePanesType('column');
let worksheet = Api.GetActiveSheet();
let freezePanes = worksheet.GetFreezePanes();
let range = freezePanes.GetLocation();
worksheet.GetRange("A1").SetValue("Location: ");
worksheet.GetRange("B1").SetValue(range.GetAddress());
builder.SaveFile("xlsx", "FreezePanes.xlsx");
builder.CloseFile();